Include or exclude hidden data when calculating totals

This procedure affects all subtotals and grand totals in the PivotTable list.

1. In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
2. Click the title bar of the PivotTable list.
3. On the toolbar, click Commands and Options , and then click the Report tab.
4. Under Calculate totals based on, do one of the following:
   • To include hidden data, select All items (including hidden items).

   • To exclude hidden data, select Visible items only.

Notes

• This setting affects data hidden by filtering row and column fields; data hidden by using filter fields is always excluded from totals.

• When you choose to include hidden data, asterisks (*) appear next to the captions of subtotals and grand totals to note that the total values include hidden items as well as displayed items.